Schema for sharing relational database types

ABSTRACT

A schema for storing the meta data that describes relational databases. Advantageously, the schema can be used in both database vendor environments and toolkit vendor environments, thereby facilitating the sharing of relational database types. In addition, by describing the schema in a standard modeling language, even among multiple implementations of storage systems designed according to the schema, the conceptual structure and understanding of each storage system can be the same.

CROSS-REFERENCE TO RELATED APPLICATIONS

This application is a divisional of U.S. patent application Ser. No.09/998,704, filed Nov. 30, 2001, issued as U.S. Pat. No. 7,133,871 onNov. 7, 2006, which claims priority from Canadian patent applicationserial no. 2,354,437, filed Jul. 31, 2001.

FIELD OF THE INVENTION

The present invention relates to relational databases and, inparticular, a schema for sharing relational database types and methodsand apparatus for employing the schema.

BACKGROUND OF THE INVENTION

Data collection is ever increasing in a world wherein more and moretransactions occur electronically. Indeed, certain applications, such asdata mining, that are made more useful by the combination of increasingprocessor power and increasing availability of data, tend to inspirefurther data collection. This inspiration to further data collection maybe seen, for instance, in the proliferation of customer reward programs.In response to this increasing availability of data, industries havebeen built up over recent decades around database technology.Specifically, active members of these industries include databasevendors, who sell databases either individually or collectively (e.g.,in a database catalog), and tool vendors, who sell software that may beused to create a new database or alter existing databases.

Relational Databases can be thought of as comprising Tables having Rowsand Columns. Unfortunately, while programming practices have largelygraduated from procedural techniques to object-oriented techniques,databases have not moved nearly as quickly toward object-orienteddesign. Hence, there is often a need for a bridge between relationaldatabases and the object-oriented programs for exploiting the datawithin relational databases. The design of a given database is describedby information known as “meta data”. Today, database vendors each havetheir own unique schema used to store meta data about each of thedatabase types contained in a given catalog. A catalog is a databasecontaining information about databases stored on a particular server, agroup of servers, or all the servers in a domain. In addition, vendorsof tools for working with databases generally provide a proprietary datastore for storing a tool's understanding of a given set of meta data.

Structured Query Language (SQL) is a standard interactive andprogramming language for getting information from, writing informationto and updating a database. SQL defines a language known as DataDefinition Language (DDL) that can be used like a set of commands tocreate or edit meta data in a database catalog. For further informationabout SQL, see “ISO Final Draft International Standard (FDIS)— DatabaseLanguage SQL—Part 2: Foundation (SQL/Foundation)”, March 99, which isincorporated herein by reference and referenced hereinafter as “the SQLspecification”.

Consider a user employing a tool vendor's product (a tool) to edit acatalog of databases from a database vendor. The result of the use ofthe tool to edit the catalog is a new catalog, formed according to rulesthat govern the operation of the tool. The user issues commands in DDLto alter the meta data in the catalog, where the meta data is storedusing a schema unique to the database vendor. The tool has to parsethese commands and examine the catalog to attempt to understand the metadata, before saving an understanding of the meta data in the newcatalog. In general this parsing leads to some data loss between metadata stores. Which is to say that the meta data in the new catalog isstored using a schema proprietary to the tool vendor. The schema islikely different from the schema used by the database vendor.

As soon as database or tool vendors wish to share meta data, the vendorsrun into this data loss problem. In general, to have complete support,bridges are built between a pair of vendors to translate the meta data.These bridges are maintenance-intensive and very vendor-pair specific.One alternative is to use a “lowest common denominator” approach,wherein only the data classifications that the two vendors share incommon may be translated. Although not as maintenance-intensive, thisapproach is very vendor-pair specific and data loss is typically an evengreater problem.

SUMMARY OF THE INVENTION

A schema is described for storing the meta data that describesrelational databases. Advantageously, the schema can be used in bothdatabase vendor environments and toolkit vendor environments, therebyfacilitating the sharing of relational database types. In addition, bydescribing the schema in a standard modeling language, even amongmultiple implementations of storage systems designed according to theschema, the conceptual structure and understanding of each storagesystem can be the same. In a preferred embodiment, the schema isimplemented using the Unified Modeling Language (UML).

In accordance with an aspect of the present invention there is provideda schema for storing meta data that describes a relational database. Theschema includes an abstract class for defining a data type of a member.The abstract class includes a property for indicating a genericStructured Query Language data type for the member, a property forindicating a database-specific data type name for the member and amethod for constructing an object instantiated from a class derived fromthe abstract class.

In accordance with another aspect of the present invention there isprovided a storage system in a database catalog. The storage systemincludes an object of a class derived from an abstract class fordefining a data type of a member. The abstract class includes a propertyfor indicating a generic Structured Query Language data type for themember, a property for indicating a database-specific data type name forthe member and a method for constructing an object instantiated from aclass derived from the abstract class.

In accordance with a further aspect of the present invention there isprovided an object-oriented description of a relational database. Theobject-oriented description includes an object for describing a type ofa member in the relational database, the object instantiated from aclass derived from an abstract class for defining a data type of amember, the abstract class includes a property for indicating a genericStructured Query Language data type for the member, a property forindicating a database-specific data type name for the member, a methodfor constructing an object instantiated from a class derived from theabstract class. In a further aspect of the present invention, there isprovided a software medium that contains the object-orienteddescription.

In accordance with a still further aspect of the present invention thereis provided a schema for storing meta data that describes a relationaldatabase. The schema includes an abstract class for naming groups ofmembers in the relational database, where the abstract class has aproperty for naming the group of the members.

In accordance with an even further aspect of the present invention thereis provided an object-oriented description of a relational database. Theobject-oriented description includes an object for referencing a groupof members in the relational database, the object instantiated from aclass derived from an abstract class for naming groups of members in therelational database, the abstract class having a property for naming thegroups of the members. In a further aspect of the present invention,there is provided a software medium that contains the object-orienteddescription.

In accordance with still another aspect of the present invention thereis provided a method of facilitating sharing of relational databasetypes. The method includes transforming a first representation ofdatabase meta data into a second representation of the database metadata, where the second representation of the database meta data followsa given schema, and storing the first representation in a repository inthe form of a set of objects of classes defined in the given schema. Inanother aspect of the present invention there is provided a computersystem for carrying out this method.

In accordance with still another aspect of the present invention thereis provided an object-oriented programming language implementation of aschema for storing meta data that describes a relational database. Theimplementation includes an abstract class for defining a data type of amember. The abstract class includes a property for indicating a genericStructured Query Language data type for the member, a property forindicating a database-specific data type name for the member and amethod for constructing an object instantiated from a class derived fromthe abstract class.

Other aspects and features of the present invention will become apparentto those of ordinary skill in the art upon review of the followingdescription of specific embodiments of the invention in conjunction withthe accompanying figures.

BRIEF DESCRIPTION OF THE DRAWINGS

In the figures which illustrate example embodiments of this invention:

FIG. 1 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBTable;

FIG. 2 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBColumn;

FIG. 3 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including an abstract classRDBUserDefinedType;

FIG. 4 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBRowType;

FIG. 5 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class SQLArray;

FIG. 6 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBAlias;

FIG. 7 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a classRDBReferenceByKey;

FIG. 8 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class SQLConstraint;

FIG. 9 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBSchema;

FIG. 10 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBDefiner;

FIG. 11 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a classRDBStructuredType;

FIG. 12 illustrates a class diagram, of the UML schema that is anembodiment of the present invention, including a class RDBDatabase; and

FIG. 13 illustrates a computer system, in communication with a database,for using the UML schema that is an embodiment of the present invention.

DETAILED DESCRIPTION OF A PREFERRED EMBODIMENT

The Unified Modeling Language (UML) is a language for specifying,visualizing, constructing and documenting the artifacts of softwaresystems, as well as for business modeling and other non-softwaresystems. The UML represents a collection of engineering practices thathave proven successful in the modeling of large and complex systems. Fora comprehensive review of the UML, see www.rational.com or a textbooksuch as Booch, et al., “The Unified Modeling Language User Guide”,Addison-Wesley, 1999 (hereby incorporated herein by reference).

In overview, a schema is provided that describes relational databasetypes and the inter-relationship between these types. Rather than use asequence of commands to describe a database type, this schema may beused to give a complete understanding of the database type. Accordingly,tool vendors and database vendors can exchange complete sets of metadata without information loss or translation. The schema of the presentinvention is provided as a UML schema in FIGS. 1-12, detaileddescriptions of which follow.

As shown in FIG. 1, a class RDBTable 102 references a classRDBStructuredType 104. Furthermore, child objects of class RDBTable mayalso reference their parent objects of class RDBTable. The classRDBTable 102, which owns an abstract class RDBNamedGroup 106 and a classRDBColumn 208, includes two properties, both of type string, called“name” and “comments”. These properties may be seen as self explanatoryin that an object of class RDBTable will have a name and associatedcomments may give a further understanding of the nature of the RDBTableobject. As also shown in FIG. 1, the class RDBColumn 208 is derived froma class RDBMember 210 which is referenced by the abstract classRDBNamedGroup 106.

The class RDBTable 102 is an aggregated definition of a single Row in aTable. The class RDBTable 102 contains, by value, an optional identity,which indirectly refers to a set of members of the structure. The typeof a Table, which is an object of class RDBTable, may either be definedby the structure type and reflected in a set of columns, or may beexplicitly defined by the columns.

A Table may have a structure type that defines the shape of the table(i.e., a description of the set of columns the table can have), as wellas an optional identity that indirectly refers to a set of members ofthe Table. The Table may also contain an optional set of named groupsthat group a set of members having a given structure type. These namedgroups can be used to identify the members that make up a primary key ora foreign key reference. Where a primary key is a column or combinationof columns in a database table that uniquely identifies each row in thetable, a foreign key reference is column or combination of columns in adatabase table that references the primary key of another table in thedatabase.

If the Table is defined by a structure type (discussed hereinafter),column definitions are computed and made immutable (i.e., the columndefinitions cannot be modified once set). If the Table has columns andis not defined by a StructureType, a StructureType cannot be associatedwith the Table.

Note that member types can inherit from other member types, so astructure type can also inherit. Thus, a Table can be defined with a setof inheritance constructs. Also, user defined types can inherit fromprimitives, and so on.

The abstract class RDBNamedGroup 106 includes a property of type string,called “name”. Simply put, an object of the abstract class RDBNamedGroup106 allows the grouping of a set of members and the subsequent naming ofthe grouped set of members. The abstract class RDBNamedGroup 106 is usedto define the identity of a group, the object references of a group,etc.

As may be understood through an examination of the role names (generallyfound at ends of the lines showing associations between classes), it maybe seen that an object of the class RDBTable 102 may own multiplenamedGroups that are objects instantiated from a class derived from theabstract class RDBNamedGroup 106. It may also be seen that thesenamedGroups are made up of members that are objects of the classRDBMember 210, that the members may be members of multiple groups andthat the object of the class RDBTable 102 provides a single nameSpacefrom which the namedGroups take their names.

As shown in FIG. 2, a class RDBField 202, which owns an abstract classRDBMemberType 204, includes a string property called “name”. The classRDBMember 210 is derived from the class RDBField 202 and includes aboolean property called “allowNull” (whose initial value should be setto true) and two string properties called “defaultValue” and “external”.As noted in conjunction with the description of FIG. 1, class RDBColumnis derived from the class RDBMember 210.

A class RDBIdentity 206 is derived from the class RDBColumn 208 andincludes two string properties, namely “startValue” and“incrementValue”. A class RDBReferenceColumn 212 is derived from theclass RDBColumn 208 and also references the class RDBColumn 208 and theclass RDBTable 102. Objects that are instantiations of classes such asclass RDBField 202, that are owned by the abstract class RDBMemberType204, have many properties in common. Thus, the abstract classRDBMemberType 204 includes three string properties, namely“externalName”, “name” and “defaultValue”, and one integer propertycalled “jdbcEnumType”. The abstract class RDBMemberType 204 alsoincludes a method named “getCopyo”.

The property “externalName” corresponds to the generic SQL data type.The property “name” corresponds to the internal data type name for aspecific domain. The value of name is a database-specific data type namefor a SQL <data type>. The property “defaultValue” is set to indicate adefault value for the member type. The property “jdbcEnumType” is setbased on a mapping to jdbc using the jdbc types per java.sql.Types. Byway of background, JDBC (Java Database Connectivity) is an applicationprogram interface (API) specification for connecting programs written inJava to the data in popular databases.

Generally, the JDBC API allows for an interface between a Java programwith a requirement to access a relational database and the relationaldatabase for which access is required. By including the property“jdbcEnumType” in the abstract class RDBMemberType 204, a database witha meta data store that follows the schema of the present invention maybe accessed by a Java program in a standard manner.

The method getcopy() is used to construct an object that is aninstantiation of a subclass of the abstract class RDBMemberType 204, setthe originatingType to the type of the original object and return a newobject of the newly constructed type.

FIG. 3 shows an abstract class RDBUserDefinedType 302. A user definedtype is made of members and methods (also known as attributes andoperations). Each user defined type provides a name scope (i.e., adomain in which each member name should be unique) to each of thesemembers and methods. Operations have name parameters that are also in aname scope.

As shown in FIG. 3, the abstract class RDBUserDefinedType 302 is derivedfrom an abstract class RDBMemberType 204 and includes two booleanproperties, called “instantiable” and “is Final”, and two stringproperties, called “orderingForm” and “orderingCategory”.

The property “instantiable” is used to indicate whether or not an objectmay be instantiated from a class derived from the abstract classRDBUserDefinedType 302 (i.e., whether the class derived from theabstract class RDBUserDefinedType 302 is also an abstract class). Theproperty “instantiable” should have an initial value of true. Theproperty “is Final” is for indicating whether a class derived from theabstract class RDBUserDefinedType 302 is final. A class is final whenthe class cannot be subclassed (i.e., extended). The initial value ofthe property “isFinal” should be false. The properties calledorderingForm orderingCategory correspond directly to properties of UserDefined Types defined in the SQL specification.

A class RDBDistinctType 306 is derived from the abstract classRDBUserDefinedType 302 and references the abstract class RDBMemberType204. Note that objects of the class RDBDistinctType 306 will exist in anobject-oriented meta data store of database types, while objects of theabstract class RDBUserDefinedType 302 and the abstract classRDBMemberType 304 will not exist.

As shown in FIG. 4, a class RDBRowType 402, which owns the classRDBField 202, is derived from the abstract class RDBUserDefinedType 302and includes a string property called “degree”.

An array is a collection in which each element is associated withexactly one ordinal position in the collection. As shown in FIG. 5, aclass SQLCollectionType 504 includes a string property called“constructor” and a class SQLArray 502 is derived from the classSQLCollectionType 504, references the abstract class RDBMemberType 304and includes a string property “maxCardinality”.

As shown in FIG. 6, a class RDBAlias 602 references the class RDBTable102 and includes a string property called “name”.

FIG. 7 shows a class RDBReferenceByKey 704. The definition ofReferenceByKey is based on the foreign key concept. It is the source ofthe relationship and has a name. It has a reference to the named groupthat is the target of the reference. An example is that theReferenceByKey points to the set of columns that contain the values thatcan be used to reference the primary keys of a target table. Note thatthe target need not be a primary key, the target could simply be a namedset of columns that make up an index.

As shown in FIG. 7, a class RDBIndex 702 is derived from the abstractclass RDBNamedGroup 106 and is referenced by the class RDBTable 102. Aclass SQLReference 706 is also derived from the abstract classRDBNamedGroup 106 and is also referenced by the class RDBTable 102. Theclass RDBReferenceByKey 704 is derived from the abstract classRDBNamedGroup 106 and references the class SQLReference 706. The classRDBReferenceByKey 704 includes two Boolean properties called,respectively, “deleteTarget” and “targetrequired” and two string-typeproperties called, respectively, “on Delete” and “on Update”.

FIG. 8 shows a class SQLConstraint 804. A constraint is a restrictionspecified on data in a database. There are the following four types ofconstraints modeled: Primary Key constraints; Foreign Key constraints;Unique constraints; and Check constraints. Primary Keys (SQLReference)and foreign keys (ReferenceByKey) are instantiated as their specificobject and a Constraint object with a reference to it. In the case of aprimary key, a foreign key and a unique constraint no body attribute isused.

As shown in FIG. 8, a class RDBTrigger 802 references the classRDBColumn 208 and the class RDBTable 102, is referenced by a classRDBSchema 902, includes three properties of type string, called “name”,“type” and “body”, and includes a property called “activationTime”,which is of type TriggerCheckTime.

The class SQLConstraint 804 references the class RDBIndex 702, and theclass RDBColumn 208 while being referenced by the class SQLReference 706and the class RDBReferenceByKey 704. The class SQLConstraint 804includes three string-type properties called “name”, “checkTime” and“body” and one property called “type” of type ConstraintType. The classRDBTable 102 owns the class SQLConstraint 804.

FIG. 8 also includes two enumerations, namely an enumerationRDBTriggerCheckTime 806 and an enumeration RDBConstraintType 808. Aswill be apparent to a person skilled in the art, enumerations arepredefined possible values for the property they are used to define.

As shown in FIG. 9, the class RDBSchema 902 references the classRDBTable 102, the class RDBTrigger 802, the class SQLConstraint 804 andthe abstract class RDBUserDefinedType 302. Further, the class RDBSchema902 is referenced by a class RDBDatabase 904 and includes a string-typeproperty called “name”. The class RDBSchema 902 name scopes all tablenames in a normal qualified name structure (3 part names). The classRDBDatabase 904 includes two string-type properties called,respectively, “name” and “comments”.

As shown in FIG. 10, a class RDBDefiner 1002 is referenced by the classSQLConstraint 804, the class RDBTable 102 and the abstract classRDBUserDefinedType 302. The definer is the ID of the person that createdthe schema definitions. Generally, a person logs in to a databasecreation tool to create a table definition. When reviewing a databasedefinition it may help to know who was responsible for definitions ofTables, Constraints and User Defined Types.

As shown in FIG. 11, a class RDBStructuredTypeImplementation 1102references the class RDBStructuredType 104 and includes four string-typeproperties called, respectively, “representation”, “jarfile”, “language”and “extemaIName”.

The class RDBStructuredType 104, which owns the class RDBMember 210, isderived from the abstract class RDBUserDefinedType 302. Child objects ofthe class RDBStructuredType 104 may reference a parent object that isalso of the class RDBStructuredType 104.

As shown in FIG. 12, the class RDBDatabase 904 references the classRDBTable 102, the class RDBAlias 602, the class RDBTrigger 802, theclass RDBSchema 902 and the class RDBStructuredType 104. In addition,the class RDBDatabase 904 is referenced by the class RDBAlias 602, theclass RDBTrigger 802 and the class RDBStructuredType 104. Properties oftype string that are included in the class RDBDatabase 904 are called“name” and “comments”. As will be apparent to a person skilled in theart, all these unidirectional relationships are in place to allow forbi-directional de-serialization by a Meta Object Facility (MOF,described hereinafter). Each of these objects are serialized in aseparate file by convention.

In a preferred embodiment, once the present schema is used to describe adatabase catalog, the meta data may then be serialized in standard XMIformat for sharing. The data may be serialized by an MOF/XMI tool kit.

The XML Meta data Interchange (XMI) format is a proposed use of theExtensible Markup Language (XML) that is intended to provide a standardway for programmers and other users to exchange information about metadata (essentially, information about what a set of data consists of andhow it is organized). Specifically, the XMI format is intended to helpprogrammers using the UML with different languages and development toolsto exchange their data models with each other. In addition, the XMIformat can also be used to exchange information about data warehouses.Effectively, the XMI format standardizes how any set of meta data isdescribed and requires users across many industries and operatingenvironments to see data the same way. The XMI format is a proposal fromthe Object Management Group (OMG) that builds on and extends theseindustry standards or recommendations: XML; UML; and Meta ObjectFacility (MOF), which is another standard from the OMG for ametamodeling and meta data repository.

As shown in FIG. 13, a computer system 1302 is in communication with adatabase 1304. The computer system 1302 may be loaded with database toolsoftware for executing methods exemplary of this invention from asoftware medium 1306 which could be a disk, a tape, a chip or a randomaccess memory containing a file downloaded from a remote source.

In operation, an object-oriented program running on the computer system1302 may, for instance, read meta data associated with the database 1304in a database vendor proprietary format. The object-oriented program maythen store the meta data to a storage system in the computer system 1302or elsewhere, while associating the meta data with the database 1304, ina format that is an implementation of the UML schema describedhereinbefore. The database 1304, in conjunction with meta data sostored, may then be shared with other computer systems familiar with theschema, without data loss. Alternatively, the computer system 1302,through the actions of the object-oriented program, may output the metadata in a data stream in XMI format, for use by another computer systemin accessing the contents of the database 1304.

For example, consider a simple customer database containing a table ofcustomer address information. Columns of the table may include “customername”, “house number”, “street name”, “apartment number”, “city”,“province” and “postal code”. If the meta data describing this table isto follow the teachings of the present invention, an object of the classRDBTable 102 will own objects of the class RDBColumn 208, each of theseobjects having a “name” property (see FIGS. 1 and 2). It may beadvantageous to group certain of these column objects, say “housenumber”, “street name” and “apartment number” into a group named “streetaddress” that is reflected in the properties of each of the objects inthe group. An object of a class, such as the class RDBIndex 702, that isderived from the abstract class RDBNamedGroup 106 may have StreetAddressas a value for the property “name”.

An alternative design that happens to exploit more aspects of thepresent invention would have the possible following structure. Acustomer database called Cust01 would be described by creating an objectof the class RDBDatabase 904 with a “name” property of Cust01 and a“description” property of customer database for region 1. The databasewould also have a Schema called CustApp which may be represented by anobject of the class RDBSchema 902 that has a “name” property with thevalue CustApp. There could also be an object of the class RDBRowType402, with a “name” property Location, that has fields with the followingnames: HouseNumber, StreetName, AptNumber, City, Province, PostalCode.Finally, there would be an object of the class RDBTable 102, with a“name” property of Customer, that is defined by an object of the classRDBStructuredType 104. The RDBTable object would be further defined tohave an object of the class RDBMember 210, with a “name” property ofAddress, that is defined by the RDBRowType object named Location, andtwo objects of the class RDBColumn 208 having “name” properties of Nameand SocialSecNum, respectively.

This example provides basically the same capability to store customerinformation as the simpler example above, but has some better designfeatures that allow for the reuse of the RDBRowType object namedLocation.

Once the meta data describing this simple database is stored in a mannerthat conforms to the schema of the present invention, the simpledatabase may be opened using a tool that understands the schema of thepresent invention. Once the simple database has been opened, the user ofthe tool may access the database in a conventional manner. For instance,the user of the tool may query the simple database for addressinformation on a particular customer. Alternatively, the simple databasemay be queried to learn the number of customers resident in a particulargeographic area, say through the use of such a constraint as postalcode.

Not only can the tool, or the user of the tool, query the database, thetool, or the user of the tool, can also see the structure of thedatabase including such information as the table names, the table types,the column names and the column types. This information may then be usedto build application code, for an application that will access thedatabase. Alternatively, the structure information may be used directlyto form a new query.

A user could, for instance, examine the various tables and columns byname and relation to one another. If the user wishes to query the simplecustomer database mentioned above with age as a constraint, it will behelpful for the user to know how the age information is stored in thedatabase. There may simply be a column named “age” or there may be threecolumns names “day of birth”, “month of birth” and “year of birth”. Inthe latter case, the user may then decide on the degree of precisionrequired for an age query.

As will be appreciated by those skilled in the art, modifications to theabove-described embodiment can be made without departing from theessence of the invention. For example, a schema for sharing relationaldatabase types is expressed above in the form of a Unified ModelingLanguage (UML) schema, but need not necessarily be expressed in the UML.Other notations, such as the Rumbaugh Object Modeling Technique or Boochnotation, may be used to express the schema.

Other modifications will be apparent to those skilled in the art and,therefore, the invention is defined in the claims.

1. A computer-implemented method of facilitating sharing of a relationaldatabase type comprising: transforming a first representation ofdatabase meta data into a second representation of said database metadata, where said second representation of said database meta datafollows a given schema, wherein the first representation defines therelational database type according to a database vendor proprietaryformat, and wherein the given schema defines a serializable set ofobject oriented classes for representing database types from a pluralityof vendors in a vendor neutral format; wherein representing the databasetypes in the vendor neutral format comprises representing the databasetypes in a manner that is not specific to any database vendor; whereinthe manner in which the database types are represented is not specificto any vendor of a tool comprising an application for editing a catalogof databases from a database vendor; and storing said transformed firstrepresentation in a repository in the form of a set of objects ofclasses defined in said given schema, and wherein said schema is aUnified Modeling Language schema.
 2. The computer-implemented method ofclaim 1, wherein the database meta data describes at least table names,column names, and column types.
 3. A computer system comprising: aprocessor, means for transforming a first representation of databasemeta data into a second representation of said database meta data, wheresaid second representation of said database meta data follows a givenschema, wherein the first representation defines the relational databasetype according to a database vendor proprietary format, and wherein thegiven schema defines a serializable set of object oriented classes forrepresenting database types from a plurality of vendors in a vendorneutral format; wherein representing the database types in the vendorneutral format comrprises representing the database types in a mannerthat is not specific to any database vendor; wherein the manner in whichthe database types are represented is not specific to any vendor of atool comprising an application for editing a catalog of databases from adatabase vendor; and means for storing said transformed fistrepresentation in a repository in the form of a set of objects ofclasses defined in said given schema, and wherein said schema is aUnified Modeling Language schema.
 4. The computer system of claim 3,wherein the database meta data describes at least table names, columnnames, and column types.
 5. A computer system comprising a processor,the computer system operable to: transform a first representation ofdatabase meta data into a second representation of said database metadata, where said second representation of said database meta datafollows a given schema, wherein the first representation defines therelational database type according to a database vendor proprietaryformat, and wherein the given schema defines a serializable set ofobject oriented classes for representing database types from a pluralityof vendors in a vendor neutral format; wherein representing the databasetypes in the vendor neutral format comprises representing the databasetypes in a manner that is not specific to any database vendor; whereinthe manner in which the database types are represented is not specificto any vendor of a tool comprising an application for editing a catalogof databases from a database vendor; and store said first representationin a repository in the form of a set of objects of classes defined insaid given schema, and wherein said schema is a Unified ModelingLanguage schema.
 6. The computer system of claim 5, wherein the databasemeta data describes at least table names, column names, and columntypes.